﻿//********************************************************************************//
//创建日期：<创建日期，2010-08-02>
//创建作者：<王一飞，wangyifei@shanghai3h.com>
//功能说明：QS_SF_YINHANGPLDLHZ实体层次
//********************************************************************************//

#region Entity

using System;
using System.Data;
using Entity;
using Oracle.DataAccess.Client;
using Platform.Configuration;
using Platform.Data;

namespace Entity
{
    [Serializable]
    public class QS_SF_YINHANGPLDLHZ
    {
        private decimal? m_dec_i_bianhao;

        private decimal? m_dec_i_jiajial;

        private decimal? m_dec_i_jihual;

        private decimal? m_dec_i_jlzt;

        private decimal? m_dec_i_shangchuanbz;

        private decimal? m_dec_i_shiyongl;

        private decimal? m_dec_i_shoufeilx;

        private decimal? m_dec_i_wtype;

        private decimal? m_dec_i_xyhs;

        private decimal? m_dec_i_yinhanglx;

        private decimal? m_dec_i_ym;

        private decimal? m_dec_i_zongbis;

        private decimal m_dec_id;

        private decimal? m_dec_n_jine;

        private decimal? m_dec_n_zongjine;

        private DateTime? m_DT_d_riqi;

        private DateTime? m_DT_d_shangchuanrq;

        private string m_str_s_hanghao;

        private string m_str_s_hetongh;

        private string m_str_s_huming;

        private string m_str_s_leixing;

        private string m_str_s_wenjianm;

        private string m_str_s_yinhang;

        private string m_str_s_yonghuh;

        private string m_str_s_yonghum;

        private string m_str_s_zhanghao;

        private string m_str_s_zhifuhh;

        /// <summary>
        /// </summary>
        public decimal ID
        {
            get { return m_dec_id; }
            set { m_dec_id = value; }
        }

        /// <summary>
        ///     文件名
        /// </summary>
        public string S_WENJIANM
        {
            get { return m_str_s_wenjianm; }
            set { m_str_s_wenjianm = value; }
        }

        /// <summary>
        ///     上传标志
        /// </summary>
        public decimal? I_SHANGCHUANBZ
        {
            get { return m_dec_i_shangchuanbz; }
            set { m_dec_i_shangchuanbz = value; }
        }

        /// <summary>
        ///     总金额
        /// </summary>
        public decimal? N_ZONGJINE
        {
            get { return m_dec_n_zongjine; }
            set { m_dec_n_zongjine = value; }
        }

        /// <summary>
        ///     总笔数
        /// </summary>
        public decimal? I_ZONGBIS
        {
            get { return m_dec_i_zongbis; }
            set { m_dec_i_zongbis = value; }
        }

        /// <summary>
        ///     收费类型
        /// </summary>
        public decimal? I_SHOUFEILX
        {
            get { return m_dec_i_shoufeilx; }
            set { m_dec_i_shoufeilx = value; }
        }

        /// <summary>
        ///     银行类型
        /// </summary>
        public decimal? I_YINHANGLX
        {
            get { return m_dec_i_yinhanglx; }
            set { m_dec_i_yinhanglx = value; }
        }

        /// <summary>
        ///     上传日期
        /// </summary>
        public DateTime? D_SHANGCHUANRQ
        {
            get { return m_DT_d_shangchuanrq; }
            set { m_DT_d_shangchuanrq = value; }
        }

        /// <summary>
        ///     i_jlzt
        /// </summary>
        public decimal? I_JLZT
        {
            get { return m_dec_i_jlzt; }
            set { m_dec_i_jlzt = value; }
        }

        /// <summary>
        ///     日期
        /// </summary>
        public DateTime? D_RIQI
        {
            get { return m_DT_d_riqi; }
            set { m_DT_d_riqi = value; }
        }

        /// <summary>
        ///     户名
        /// </summary>
        public string S_HUMING
        {
            get { return m_str_s_huming; }
            set { m_str_s_huming = value; }
        }

        /// <summary>
        ///     帐号
        /// </summary>
        public string S_ZHANGHAO
        {
            get { return m_str_s_zhanghao; }
            set { m_str_s_zhanghao = value; }
        }

        /// <summary>
        ///     银行
        /// </summary>
        public string S_YINHANG
        {
            get { return m_str_s_yinhang; }
            set { m_str_s_yinhang = value; }
        }

        /// <summary>
        ///     行号
        /// </summary>
        public string S_HANGHAO
        {
            get { return m_str_s_hanghao; }
            set { m_str_s_hanghao = value; }
        }

        /// <summary>
        ///     金额
        /// </summary>
        public decimal? N_JINE
        {
            get { return m_dec_n_jine; }
            set { m_dec_n_jine = value; }
        }

        /// <summary>
        ///     合同号
        /// </summary>
        public string S_HETONGH
        {
            get { return m_str_s_hetongh; }
            set { m_str_s_hetongh = value; }
        }

        /// <summary>
        ///     用户号
        /// </summary>
        public string S_YONGHUH
        {
            get { return m_str_s_yonghuh; }
            set { m_str_s_yonghuh = value; }
        }

        /// <summary>
        ///     类型
        /// </summary>
        public string S_LEIXING
        {
            get { return m_str_s_leixing; }
            set { m_str_s_leixing = value; }
        }

        /// <summary>
        ///     iWaterType
        /// </summary>
        public decimal? I_WTYPE
        {
            get { return m_dec_i_wtype; }
            set { m_dec_i_wtype = value; }
        }

        /// <summary>
        ///     年月
        /// </summary>
        public decimal? I_YM
        {
            get { return m_dec_i_ym; }
            set { m_dec_i_ym = value; }
        }

        /// <summary>
        ///     计划量
        /// </summary>
        public decimal? I_JIHUAL
        {
            get { return m_dec_i_jihual; }
            set { m_dec_i_jihual = value; }
        }

        /// <summary>
        ///     实用量
        /// </summary>
        public decimal? I_SHIYONGL
        {
            get { return m_dec_i_shiyongl; }
            set { m_dec_i_shiyongl = value; }
        }

        /// <summary>
        ///     加价量
        /// </summary>
        public decimal? I_JIAJIAL
        {
            get { return m_dec_i_jiajial; }
            set { m_dec_i_jiajial = value; }
        }

        /// <summary>
        ///     用户名
        /// </summary>
        public string S_YONGHUM
        {
            get { return m_str_s_yonghum; }
            set { m_str_s_yonghum = value; }
        }

        /// <summary>
        ///     I_XYH_S
        /// </summary>
        public decimal? I_XYHS
        {
            get { return m_dec_i_xyhs; }
            set { m_dec_i_xyhs = value; }
        }

        /// <summary>
        ///     支付行号
        /// </summary>
        public string S_ZHIFUHH
        {
            get { return m_str_s_zhifuhh; }
            set { m_str_s_zhifuhh = value; }
        }

        /// <summary>
        ///     编号
        /// </summary>
        public decimal? I_BIANHAO
        {
            get { return m_dec_i_bianhao; }
            set { m_dec_i_bianhao = value; }
        }
    }
}

#endregion

#region EntityProcess

namespace BLL.Access
{
    //using System.Data.OracleClient;

    public class QS_SF_YINHANGPLDLHZProcess
    {
        #region Field

        protected string conn;

        #endregion

        #region Construction

        public QS_SF_YINHANGPLDLHZProcess()
        {
            conn = ConfigHelper.PlatformConnString;
        }

        #endregion

        #region public

        /// <summary>
        ///     根据QS_SF_YINHANGPLDLHZ实体添加或者修改QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        public bool InsertOrUpdate(QS_SF_YINHANGPLDLHZ QS_SF_YINHANGPLDLHZ, OracleTransaction Transaction)
        {
            if (QS_SF_YINHANGPLDLHZ.ID == 0)
                InsertQS_SF_YINHANGPLDLHZ(QS_SF_YINHANGPLDLHZ, Transaction);
            else
                UpdateQS_SF_YINHANGPLDLHZ(QS_SF_YINHANGPLDLHZ, Transaction);
            return QS_SF_YINHANGPLDLHZ.ID == 0 ? false : true;
        }

        /// <summary>
        ///     根据QS_SF_YINHANGPLDLHZ实体添加或修改QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        public bool InsertOrUpdate(QS_SF_YINHANGPLDLHZ QS_SF_YINHANGPLDLHZ)
        {
            return InsertOrUpdate(QS_SF_YINHANGPLDLHZ, null);
        }


        /// <summary>
        ///     根据QS_SF_YINHANGPLDLHZ主键删除QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="ID"></param>
        public bool DeleteQS_SF_YINHANGPLDLHZ(decimal ID, OracleTransaction Transaction)
        {
            var spName = "CS_DelQS_SF_YINHANGPLDLHZ";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = ID;
            var result = 0;
            if (Transaction == null)
                result = OracleHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                result = OracleHelper.ExecuteNonQuery(Transaction, CommandType.StoredProcedure, spName, storedParams);
            return result == 0 ? false : true;
        }

        /// <summary>
        ///     根据QS_SF_YINHANGPLDLHZ主键删除QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="ID"></param>
        public bool DeleteQS_SF_YINHANGPLDLHZ(decimal ID)
        {
            return DeleteQS_SF_YINHANGPLDLHZ(ID, null);
        }

        /// <summary>
        ///     根据条件删除QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="WhereClause">条件子句(Oracle语句)不带where</param>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>如果删除成功，返回true,否则返回fals</returns>
        public bool DeleteQS_SF_YINHANGPLDLHZsDynamic(string WhereClause, OracleTransaction Transaction)
        {
            var spName = "CS_DelQS_SF_YINHANGPLDLHZsDyn";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = WhereClause;
            var result = 0;
            if (Transaction == null)
                result = OracleHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                result = OracleHelper.ExecuteNonQuery(Transaction, CommandType.StoredProcedure, spName, storedParams);
            return result == 0 ? false : true;
        }

        /// <summary>
        ///     根据条件删除QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="WhereClause">条件子句(Oracle语句)不带where</param>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>如果删除成功，返回true,否则返回fals</returns>
        public bool DeleteQS_SF_YINHANGPLDLHZsDynamic(string WhereClause)
        {
            return DeleteQS_SF_YINHANGPLDLHZsDynamic(WhereClause, null);
        }

        /// <summary>
        ///     根据QS_SF_YINHANGPLDLHZ主键选择QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>QS_SF_YINHANGPLDLHZ信息</returns>
        public QS_SF_YINHANGPLDLHZ SelectQS_SF_YINHANGPLDLHZ(decimal ID, OracleTransaction Transaction)
        {
            var spName = "CS_SelQS_SF_YINHANGPLDLHZ";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = ID;
            OracleDataReader rd;
            if (Transaction == null)
                rd = OracleHelper.ExecuteReader(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                rd = OracleHelper.ExecuteReader(Transaction, CommandType.StoredProcedure, spName, storedParams);
            if (rd.Read())
            {
                var QS_SF_YINHANGPLDLHZ = PopulateQS_SF_YINHANGPLDLHZ(rd);
                rd.Close();
                return QS_SF_YINHANGPLDLHZ;
            }
            return null;
        }

        /// <summary>
        ///     根据QS_SF_YINHANGPLDLHZ主键选择QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <returns>QS_SF_YINHANGPLDLHZ信息</returns>
        public QS_SF_YINHANGPLDLHZ SelectQS_SF_YINHANGPLDLHZ(decimal ID)
        {
            return SelectQS_SF_YINHANGPLDLHZ(ID, null);
        }

        /// <summary>
        ///     选择所有QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>所有QS_SF_YINHANGPLDLHZ信息</returns>
        public DataTable SelectQS_SF_YINHANGPLDLHZsAll(OracleTransaction Transaction)
        {
            var spName = "CS_SelQS_SF_YINHANGPLDLHZsAll";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            DataSet ds = null;
            if (Transaction == null)
                ds = OracleHelper.ExecuteDataset(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(Transaction, CommandType.StoredProcedure, spName, storedParams);
            if (ds != null && ds.Tables.Count > 0)
            {
                AddRowNumber(ds.Tables[0]);
                return ds.Tables[0];
            }
            return null;
        }

        /// <summary>
        ///     选择所有QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <returns>所有QS_SF_YINHANGPLDLHZ信息</returns>
        public DataTable SelectQS_SF_YINHANGPLDLHZsAll()
        {
            return SelectQS_SF_YINHANGPLDLHZsAll(null);
        }

        /// <summary>
        ///     根据条件选择QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="WhereClause">条件子句(不带where)</param>
        /// <param name="OrderByExpression">排序子句</param>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>QS_SF_YINHANGPLDLHZ信息</returns>
        public DataTable SelectQS_SF_YINHANGPLDLHZsDynamic(string WhereClause, string OrderByExpression,
            OracleTransaction Transaction)
        {
            var spName = "CS_SelQS_SF_YINHANGPLDLHZsDyn";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = string.IsNullOrEmpty(WhereClause.Trim()) ? "1=1" : WhereClause;
            storedParams[1].Value = OrderByExpression;
            DataSet ds = null;
            if (Transaction == null)
                ds = OracleHelper.ExecuteDataset(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(Transaction, CommandType.StoredProcedure, spName, storedParams);
            if (ds != null && ds.Tables.Count > 0)
            {
                AddRowNumber(ds.Tables[0]);
                return ds.Tables[0];
            }
            return null;
        }


        /// <summary>
        ///     根据条件选择QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="WhereClause">条件子句(不带where)</param>
        /// <param name="OrderByExpression">排序子句</param>
        /// <returns>QS_SF_YINHANGPLDLHZ信息</returns>
        public DataTable SelectQS_SF_YINHANGPLDLHZsDynamic(string WhereClause, string OrderByExpression)
        {
            return SelectQS_SF_YINHANGPLDLHZsDynamic(WhereClause, OrderByExpression, null);
        }


        /// <summary>
        ///     根据条件选择QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="WhereClause">条件子句(不带where)</param>
        /// <param name="OrderByExpression">排序子句</param>
        /// <param name="PageIndex">页码</param>
        /// <param name="PageSize">页数</param>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>QS_SF_YINHANGPLDLHZ信息</returns>
        public DataTable SelectQS_SF_YINHANGPLDLHZsDynamic(string WhereClause, string OrderByExpression, int PageIndex,
            int PageSize, OracleTransaction Transaction)
        {
            var spName = "CS_SelQS_SF_YINHANGPLDLHZsDynPaged";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = string.IsNullOrEmpty(WhereClause.Trim()) ? "1=1" : WhereClause;
            storedParams[1].Value = OrderByExpression;
            storedParams[2].Value = PageIndex;
            storedParams[3].Value = PageSize;
            DataSet ds = null;
            if (Transaction == null)
                ds = OracleHelper.ExecuteDataset(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(Transaction, CommandType.StoredProcedure, spName, storedParams);
            if (ds != null && ds.Tables.Count > 0)
            {
                AddRowNumber(ds.Tables[0]);
                return ds.Tables[0];
            }
            return null;
        }


        /// <summary>
        ///     根据条件选择QS_SF_YINHANGPLDLHZ信息
        /// </summary>
        /// <param name="WhereClause">条件子句(不带where)</param>
        /// <param name="OrderByExpression">排序子句</param>
        /// <param name="PageIndex">页码</param>
        /// <param name="PageSize">页数</param>
        /// <returns>QS_SF_YINHANGPLDLHZ信息</returns>
        public DataTable SelectQS_SF_YINHANGPLDLHZsDynamic(string WhereClause, string OrderByExpression, int PageIndex,
            int PageSize)
        {
            return SelectQS_SF_YINHANGPLDLHZsDynamic(WhereClause, OrderByExpression, PageIndex, PageSize, null);
        }

        /// <summary>
        ///     根据条件更新QS_SF_YINHANGPLDLHZ字段
        /// </summary>
        /// <returns>受影响行数</returns>
        public int UpdateQS_SF_YINHANGPLDLHZsDynamic(string UpdateValue, string WhereClause,
            OracleTransaction Transaction)
        {
            var result = 0;
            if (UpdateValue == "" || WhereClause == "")
                return 0;
            var spName = "CS_UpdQS_SF_YINHANGPLDLHZDyn";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            DataSet ds = null;
            storedParams[0].Value = UpdateValue;
            storedParams[1].Value = WhereClause;
            if (Transaction == null)
                ds = OracleHelper.ExecuteDataset(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(Transaction, CommandType.StoredProcedure, spName, storedParams);
            result = Convert.ToInt32(storedParams[2].Value);
            return result;
        }

        /// <summary>
        ///     根据条件更新QS_SF_YINHANGPLDLHZ字段
        /// </summary>
        /// <returns>受影响行数</returns>
        public int UpdateQS_SF_YINHANGPLDLHZsDynamic(string UpdateValue, string WhereClause)
        {
            return UpdateQS_SF_YINHANGPLDLHZsDynamic(UpdateValue, WhereClause, null);
        }

        #endregion

        #region Private

        private int InsertQS_SF_YINHANGPLDLHZ(QS_SF_YINHANGPLDLHZ QS_SF_YINHANGPLDLHZ, OracleTransaction Transaction)
        {
            var spName = "CS_InsQS_SF_YINHANGPLDLHZ";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = QS_SF_YINHANGPLDLHZ.S_WENJIANM;
            storedParams[1].Value = QS_SF_YINHANGPLDLHZ.I_SHANGCHUANBZ;
            storedParams[2].Value = QS_SF_YINHANGPLDLHZ.N_ZONGJINE;
            storedParams[3].Value = QS_SF_YINHANGPLDLHZ.I_ZONGBIS;
            storedParams[4].Value = QS_SF_YINHANGPLDLHZ.I_SHOUFEILX;
            storedParams[5].Value = QS_SF_YINHANGPLDLHZ.I_YINHANGLX;
            storedParams[6].Value = QS_SF_YINHANGPLDLHZ.D_SHANGCHUANRQ;
            storedParams[7].Value = QS_SF_YINHANGPLDLHZ.I_JLZT;
            storedParams[8].Value = QS_SF_YINHANGPLDLHZ.D_RIQI;
            storedParams[9].Value = QS_SF_YINHANGPLDLHZ.S_HUMING;
            storedParams[10].Value = QS_SF_YINHANGPLDLHZ.S_ZHANGHAO;
            storedParams[11].Value = QS_SF_YINHANGPLDLHZ.S_YINHANG;
            storedParams[12].Value = QS_SF_YINHANGPLDLHZ.S_HANGHAO;
            storedParams[13].Value = QS_SF_YINHANGPLDLHZ.N_JINE;
            storedParams[14].Value = QS_SF_YINHANGPLDLHZ.S_HETONGH;
            storedParams[15].Value = QS_SF_YINHANGPLDLHZ.S_YONGHUH;
            storedParams[16].Value = QS_SF_YINHANGPLDLHZ.S_LEIXING;
            storedParams[17].Value = QS_SF_YINHANGPLDLHZ.I_WTYPE;
            storedParams[18].Value = QS_SF_YINHANGPLDLHZ.I_YM;
            storedParams[19].Value = QS_SF_YINHANGPLDLHZ.I_JIHUAL;
            storedParams[20].Value = QS_SF_YINHANGPLDLHZ.I_SHIYONGL;
            storedParams[21].Value = QS_SF_YINHANGPLDLHZ.I_JIAJIAL;
            storedParams[22].Value = QS_SF_YINHANGPLDLHZ.S_YONGHUM;
            storedParams[23].Value = QS_SF_YINHANGPLDLHZ.I_XYHS;
            storedParams[24].Value = QS_SF_YINHANGPLDLHZ.S_ZHIFUHH;
            storedParams[25].Value = QS_SF_YINHANGPLDLHZ.I_BIANHAO;
            var result = 0;
            if (Transaction == null)
                result = OracleHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                result = OracleHelper.ExecuteNonQuery(Transaction, CommandType.StoredProcedure, spName, storedParams);
            QS_SF_YINHANGPLDLHZ.ID = Convert.ToInt32(storedParams[26].Value);
            return result;
        }

        private bool UpdateQS_SF_YINHANGPLDLHZ(QS_SF_YINHANGPLDLHZ QS_SF_YINHANGPLDLHZ, OracleTransaction Transaction)
        {
            var spName = "CS_UpdQS_SF_YINHANGPLDLHZ";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = QS_SF_YINHANGPLDLHZ.S_WENJIANM;
            storedParams[1].Value = QS_SF_YINHANGPLDLHZ.I_SHANGCHUANBZ;
            storedParams[2].Value = QS_SF_YINHANGPLDLHZ.N_ZONGJINE;
            storedParams[3].Value = QS_SF_YINHANGPLDLHZ.I_ZONGBIS;
            storedParams[4].Value = QS_SF_YINHANGPLDLHZ.I_SHOUFEILX;
            storedParams[5].Value = QS_SF_YINHANGPLDLHZ.I_YINHANGLX;
            storedParams[6].Value = QS_SF_YINHANGPLDLHZ.D_SHANGCHUANRQ;
            storedParams[7].Value = QS_SF_YINHANGPLDLHZ.I_JLZT;
            storedParams[8].Value = QS_SF_YINHANGPLDLHZ.D_RIQI;
            storedParams[9].Value = QS_SF_YINHANGPLDLHZ.S_HUMING;
            storedParams[10].Value = QS_SF_YINHANGPLDLHZ.S_ZHANGHAO;
            storedParams[11].Value = QS_SF_YINHANGPLDLHZ.S_YINHANG;
            storedParams[12].Value = QS_SF_YINHANGPLDLHZ.S_HANGHAO;
            storedParams[13].Value = QS_SF_YINHANGPLDLHZ.N_JINE;
            storedParams[14].Value = QS_SF_YINHANGPLDLHZ.S_HETONGH;
            storedParams[15].Value = QS_SF_YINHANGPLDLHZ.S_YONGHUH;
            storedParams[16].Value = QS_SF_YINHANGPLDLHZ.S_LEIXING;
            storedParams[17].Value = QS_SF_YINHANGPLDLHZ.I_WTYPE;
            storedParams[18].Value = QS_SF_YINHANGPLDLHZ.I_YM;
            storedParams[19].Value = QS_SF_YINHANGPLDLHZ.I_JIHUAL;
            storedParams[20].Value = QS_SF_YINHANGPLDLHZ.I_SHIYONGL;
            storedParams[21].Value = QS_SF_YINHANGPLDLHZ.I_JIAJIAL;
            storedParams[22].Value = QS_SF_YINHANGPLDLHZ.S_YONGHUM;
            storedParams[23].Value = QS_SF_YINHANGPLDLHZ.I_XYHS;
            storedParams[24].Value = QS_SF_YINHANGPLDLHZ.S_ZHIFUHH;
            storedParams[25].Value = QS_SF_YINHANGPLDLHZ.I_BIANHAO;
            storedParams[26].Value = QS_SF_YINHANGPLDLHZ.ID;
            var result = 0;
            if (Transaction == null)
                result = OracleHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                result = OracleHelper.ExecuteNonQuery(Transaction, CommandType.StoredProcedure, spName, storedParams);
            return result == 0 ? false : true;
        }


        private QS_SF_YINHANGPLDLHZ PopulateQS_SF_YINHANGPLDLHZ(IDataReader dr)
        {
            var QS_SF_YINHANGPLDLHZ = new QS_SF_YINHANGPLDLHZ();
            QS_SF_YINHANGPLDLHZ.ID = dr["ID"] == DBNull.Value ? 0 : (decimal) dr["ID"];
            QS_SF_YINHANGPLDLHZ.S_WENJIANM = dr["S_WENJIANM"] == DBNull.Value ? null : (string) dr["S_WENJIANM"];
            QS_SF_YINHANGPLDLHZ.I_SHANGCHUANBZ =
                dr["I_SHANGCHUANBZ"] == DBNull.Value ? null : (decimal?) dr["I_SHANGCHUANBZ"];
            QS_SF_YINHANGPLDLHZ.N_ZONGJINE = dr["N_ZONGJINE"] == DBNull.Value ? null : (decimal?) dr["N_ZONGJINE"];
            QS_SF_YINHANGPLDLHZ.I_ZONGBIS = dr["I_ZONGBIS"] == DBNull.Value ? null : (decimal?) dr["I_ZONGBIS"];
            QS_SF_YINHANGPLDLHZ.I_SHOUFEILX = dr["I_SHOUFEILX"] == DBNull.Value ? null : (decimal?) dr["I_SHOUFEILX"];
            QS_SF_YINHANGPLDLHZ.I_YINHANGLX = dr["I_YINHANGLX"] == DBNull.Value ? null : (decimal?) dr["I_YINHANGLX"];
            QS_SF_YINHANGPLDLHZ.D_SHANGCHUANRQ =
                dr["D_SHANGCHUANRQ"] == DBNull.Value ? null : (DateTime?) dr["D_SHANGCHUANRQ"];
            QS_SF_YINHANGPLDLHZ.I_JLZT = dr["I_JLZT"] == DBNull.Value ? null : (decimal?) dr["I_JLZT"];
            QS_SF_YINHANGPLDLHZ.D_RIQI = dr["D_RIQI"] == DBNull.Value ? null : (DateTime?) dr["D_RIQI"];
            QS_SF_YINHANGPLDLHZ.S_HUMING = dr["S_HUMING"] == DBNull.Value ? null : (string) dr["S_HUMING"];
            QS_SF_YINHANGPLDLHZ.S_ZHANGHAO = dr["S_ZHANGHAO"] == DBNull.Value ? null : (string) dr["S_ZHANGHAO"];
            QS_SF_YINHANGPLDLHZ.S_YINHANG = dr["S_YINHANG"] == DBNull.Value ? null : (string) dr["S_YINHANG"];
            QS_SF_YINHANGPLDLHZ.S_HANGHAO = dr["S_HANGHAO"] == DBNull.Value ? null : (string) dr["S_HANGHAO"];
            QS_SF_YINHANGPLDLHZ.N_JINE = dr["N_JINE"] == DBNull.Value ? null : (decimal?) dr["N_JINE"];
            QS_SF_YINHANGPLDLHZ.S_HETONGH = dr["S_HETONGH"] == DBNull.Value ? null : (string) dr["S_HETONGH"];
            QS_SF_YINHANGPLDLHZ.S_YONGHUH = dr["S_YONGHUH"] == DBNull.Value ? null : (string) dr["S_YONGHUH"];
            QS_SF_YINHANGPLDLHZ.S_LEIXING = dr["S_LEIXING"] == DBNull.Value ? null : (string) dr["S_LEIXING"];
            QS_SF_YINHANGPLDLHZ.I_WTYPE = dr["I_WTYPE"] == DBNull.Value ? null : (decimal?) dr["I_WTYPE"];
            QS_SF_YINHANGPLDLHZ.I_YM = dr["I_YM"] == DBNull.Value ? null : (decimal?) dr["I_YM"];
            QS_SF_YINHANGPLDLHZ.I_JIHUAL = dr["I_JIHUAL"] == DBNull.Value ? null : (decimal?) dr["I_JIHUAL"];
            QS_SF_YINHANGPLDLHZ.I_SHIYONGL = dr["I_SHIYONGL"] == DBNull.Value ? null : (decimal?) dr["I_SHIYONGL"];
            QS_SF_YINHANGPLDLHZ.I_JIAJIAL = dr["I_JIAJIAL"] == DBNull.Value ? null : (decimal?) dr["I_JIAJIAL"];
            QS_SF_YINHANGPLDLHZ.S_YONGHUM = dr["S_YONGHUM"] == DBNull.Value ? null : (string) dr["S_YONGHUM"];
            QS_SF_YINHANGPLDLHZ.I_XYHS = dr["I_XYHS"] == DBNull.Value ? null : (decimal?) dr["I_XYHS"];
            QS_SF_YINHANGPLDLHZ.S_ZHIFUHH = dr["S_ZHIFUHH"] == DBNull.Value ? "" : (string) dr["S_ZHIFUHH"];
            QS_SF_YINHANGPLDLHZ.I_BIANHAO = dr["I_BIANHAO"] == DBNull.Value ? null : (decimal?) dr["I_BIANHAO"];
            return QS_SF_YINHANGPLDLHZ;
        }


        private void AddRowNumber(DataTable dt)
        {
            dt.Columns.Add(new DataColumn("RowNumber", typeof(int)));
            for (var i = 0; i < dt.Rows.Count; i++)
                dt.Rows[i][dt.Columns.Count - 1] = i + 1;
        }

        #endregion
    }
}

#endregion